package org.study.clickhouse.mybatis.boot.mapper;

import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * 具体操作数据库的 mapper 接口
 *
 * @author Administrator
 * @date 2021-05-24
 */
public interface DmlMapper {
    @Select("show databases")
    List<String> showDatabases();

    @Select("show create database ${databaseName}")
    String showCreateDatabase(String databaseName);

    @Select("show tables")
    List<String> showTables();

    @Select("desc ${tableName}")
    List<Map<String, Object>> descTables(String tableName);

    @Select("show create table ${databaseName}")
    String showCreateTable(String tableName);
}

